﻿

CREATE VIEW [dbo].[fares_ParteneriCUI]
AS
SELECT     IDPartener, CodUnitate, CUI, Denumire + ' (' + LTRIM(RTRIM(CAST(CUI AS VARCHAR(20)))) + ')' AS Denumire, ConditiiDePlata, ContClient, Cont
FROM         dbo.Parteneri